.. _`Unpivot Table`:

.. _`org.sysess.sympathy.data.table.unpivottablenode`:

Unpivot Table
~~~~~~~~~~~~~

.. image:: pivot_table.svg
   :width: 48






**Documentation**

Unpivot a Table.

The inverse operation of Pivot Table. The operation transforms data from a
wide to a narrow format. The wide form can be considered as a matrix of
column values, while the narrow form is a natural encoding of a sparse
matrix. When the data types of value columns differ, the varying data is
converted to a common data type so the source data can be part of one
single column in the new data set.


**Definition**


*Input ports*

    :Input:  table

        Input Table


*Output ports*

    :Output:  table

        Output Table



*Configuration*:
    **Index column** (index)
        Column that contains a unique identifier for each row

.. automodule:: node_unpivot_table
    :noindex:

.. class:: UnpivotTable
    :noindex:






**Example flows**

* :download:`PivotTable.syx </_examples/Sympathy/Data Processing/Structure/PivotTable.syx>`